2013-02-20 - 5793 - Spec - Scorecard Open Order Subreport #CrystalReportsSupport
SPECIFICATIONS
5793 - Scorecard Open Order Subreport
Requirement Summary
Redesign Scorecard Open Order Subreport to remove the Currency Conversion files and Repository functions, for performance optimization.
Admin Info
Purpose
|
Redesign Scorecard Open Order Subreport for performance optimization.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
02/28/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Scorecard Open Order Sub report Crystal Report
BEx Query ZSDC_OPN_Q035
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
Redesign the Scorecard Open Order Subreport to reduce the usage of Currency converison files and Repository functions in Crystal Reports, to increase the performance. Currently the report is taking around 20 minutes to run in Crystal Report Designer and it needs to be optimized using a new BEx query & MDX connection to reduce the overall processing time.
Solution Summary
- The report need to be pointed to a new BEx query that will handle currency conversions and the functionality of repository functions used.
- Currently Scorecard Open Order Sub report is using BW query driver but needs to be converted to MDX connection for better performance.
- The new BEx query should have Profit Center restriction, Currency Conversion to USD along with Fiscal Year and Fiscal Year Period fields.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Execute the new Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
2
|
Schedule the Crystal Report in NEC Infoview.
|
Report should execute successfully in NEC Infoview.
|
3
|
Validate the report with NEC Enterprise production report.
|
Report should successfully validate with NEC Enterprise production report.
|
Solution Details
Step 1: Need to create new BEx query ZSDC_OPN_Q035 in NBP with Profit Center restriction, Currency Conversion to USD and add new fields Fiscal Year and Fiscal Year Period.
Step 2: Save the report from NEC Infoview onto local machine desktop.
Step 3: Change connection from existing BW Query to New MDX driver Query.
Step 4: Remove the restriction for Profit Center from the report as the restriction is included in new BEx query.
Step 5: Change the Fiscal Year and Fiscal Year Period formulas using the new fields.
Step 6: Eliminate unused formulas from the Report.
Step 7: Execute the report in Crystal Report Designer and also schedule it in NEC Infoview.
Step 8: Check the report and validate it against the production report for correct data.
Step 9: Once the validation is successful, report to NEC so that they can move the report into the actual production folder.
Issues
None